
CREATE EXTERNAL TABLE jms_dwd.dwd_tmsnew_shipment_stop_union_base_hi
(
    id                           bigint COMMENT '经停点编码',
    shipment_id                  bigint COMMENT '任务ID',
    shipment_no                  string COMMENT '任务编号',
    sort_num                     bigint COMMENT '顺序编号',
    network_id                   bigint COMMENT '经停网点ID',
    network_code                 string COMMENT '经停网点编号',
    network_name                  string COMMENT '经停网点名称',
    roadsection_id               bigint COMMENT '路段编号',
    planned_arrival_day          string COMMENT '计划到达日期',
    planned_arrival_hour         string COMMENT '计划到达时间',
    planned_arrival_time         timestamp COMMENT '计划到达日期+时间',
    actual_arrival_time          timestamp COMMENT '实际到达时间',
    planned_departure_day        string COMMENT '计划离开日期',
    planned_departure_hour       string COMMENT '计划离开时间',
    planned_departure_time       timestamp COMMENT '计划离开日期+时间',
    actual_departure_time        timestamp COMMENT '实际离开时间',
    stop_time                    bigint COMMENT '经停时长',
    usetime                      bigint COMMENT '运输耗时(MIN)',
    mileage                      double COMMENT '规划里程(KM)',
    speed                        double COMMENT '时速(KM/H)',
    batch_time                   string COMMENT '批次时间',
    handling_type                string COMMENT '装卸类型',
    load_start_time              timestamp COMMENT '开始装货',
    load_end_time                timestamp COMMENT '装货完成',
    unload_start_time            timestamp COMMENT '开始卸货',
    unload_end_time              timestamp COMMENT '卸货完成',
    app_arrival_time             timestamp COMMENT 'APP到达时间',
    app_departure_time           timestamp COMMENT 'APP离开时间',
    gps_arrival_time             timestamp COMMENT 'GPS到达时间',
    gps_departure_time           timestamp COMMENT 'GPS离开时间',
    lock_time                    timestamp COMMENT '锁车时间',
    unlock_time                  timestamp COMMENT '解锁时间',
    weight_arrival_time          timestamp COMMENT '过磅进站时间',
    weight_departure_time        timestamp COMMENT '过磅出站时间',
    arrival_gross_weight         double COMMENT '到达毛重',
    arrival_tare_weight          double COMMENT '到达皮重',
    arrival_net_weight           double COMMENT '到达净重',
    departure_gross_weight       double COMMENT '离开毛重',
    departure_tare_weight        double COMMENT '离开皮重',
    departure_net_weight         double COMMENT '离开净重',
    estimate_arrival_time        timestamp COMMENT '预计到达时间=上一站实际发车时间+本站运输耗时(MIN)',
    plan_driving_time            bigint COMMENT '规定行驶时间',
    actual_driving_time          bigint COMMENT '实际行驶时间',
    actual_arrival_time_source   string COMMENT '实际进站时间来源',
    actual_departure_time_source string COMMENT '实际出站时间来源',
    estimate_batch_time          timestamp COMMENT '应赶批次',
    actual_batch_time            timestamp COMMENT '实赶批次时间',
    create_by                    bigint COMMENT '创建人ID',
    create_by_name               string COMMENT '创建人姓名',
    create_time                  timestamp COMMENT '创建时间',
    update_by                    bigint COMMENT '更新人ID',
    update_by_name               string COMMENT '更新人姓名',
    update_time                  timestamp COMMENT '更新时间',
    simple_name                  string COMMENT '网点简称',
    latest_arrival_time          timestamp COMMENT '最晚到车日期+时间',
    latest_arrival_hour          string COMMENT '最晚到车时间',
    latest_arrival_day           string COMMENT '最晚到车日期',
    gps_depart_mileage           double COMMENT 'GPS发车里程',
    gps_arrival_mileage          double COMMENT 'GPS到车里程',
    is_send                      tinyint COMMENT '是否发送gps发车预警消息',
    financial_center_id          bigint COMMENT '代理区ID',
    financial_center_code        string COMMENT '代理区CODE',
    financial_center_desc        string COMMENT '代理区名称',
    clock_time                   timestamp COMMENT '中心签到时间',
    table_type                   tinyint COMMENT '类型；1,干线；2,支线'
)
    COMMENT '干线支线经停点表'
        PARTITIONED BY
        (
        dt string COMMENT '时间分区yyyy-MM-dd'
        )
    stored as parquet
    LOCATION
        '/dw/hive/jms_dwd.db/external/dwd_tmsnew_shipment_stop_union_base_hi'

